SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE VIEW [dbo].[vThread]
AS
SELECT     dbo.Message.Subject, dbo.Message.Body, dbo.Member.Name AS SenderName, 
                      dbo.Position.Name AS PositionName, dbo.Committee.Name AS CommitteeName, dbo.ThreadType.Name AS TypeName, 
                      dbo.Message.Id AS MessageId, dbo.Member.Id AS SenderId, dbo.Message.SentDate, 
                      dbo.Thread.Id AS ThreadId
FROM         dbo.Message INNER JOIN
                      dbo.Member ON dbo.Message.SenderId = dbo.Member.Id INNER JOIN
                      dbo.Position ON dbo.Member.CurrentPostionId = dbo.Position.Id INNER JOIN
                      dbo.Committee ON dbo.Member.CurrentCommitteeId = dbo.Committee.Id INNER JOIN
                      dbo.Thread ON dbo.Message.ThreadId = dbo.Thread.Id INNER JOIN
                      dbo.ThreadType ON dbo.Thread.TypeId = dbo.ThreadType.Id INNER JOIN
                          (SELECT     ThreadId, MAX(Id) AS Id
                             FROM         dbo.Message AS m
                             GROUP BY ThreadId) AS tbl ON dbo.Message.Id = tbl.Id

GO
EXEC sp_addextendedproperty N'MS_DiagramPane1', N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[44] 4[17] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Message"
            Begin Extent = 
               Top = 20
               Left = 649
               Bottom = 175
               Right = 809
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Member"
            Begin Extent = 
               Top = 6
               Left = 236
               Bottom = 182
               Right = 423
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Position"
            Begin Extent = 
               Top = 139
               Left = 39
               Bottom = 228
               Right = 199
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Committee"
            Begin Extent = 
               Top = 9
               Left = 23
               Bottom = 128
               Right = 183
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Thread"
            Begin Extent = 
               Top = 6
               Left = 1055
               Bottom = 95
               Right = 1215
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "ThreadType"
            Begin Extent = 
               Top = 108
               Left = 1047
               Bottom = 212
               Right = 1207
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "tbl"
            Begin Extent = 
               Top = 6
               Left = 461
               Bottom = 95
               Right = 621
            End
            DisplayFlags = 280
 ', 'SCHEMA', N'dbo', 'VIEW', N'vThread', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_DiagramPane2', N'           TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 11
         Width = 284
         Width = 1500
         Width = 1995
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
', 'SCHEMA', N'dbo', 'VIEW', N'vThread', NULL, NULL
GO
DECLARE @xp int
SELECT @xp=2
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', @xp, 'SCHEMA', N'dbo', 'VIEW', N'vThread', NULL, NULL
GO
